﻿CREATE TABLE [dbo].[human_Persons] (
    [PersonID]        INT            IDENTITY (1, 1) NOT NULL,
    [FirstName]       NVARCHAR (150) NOT NULL,
    [LastName]        NVARCHAR (150) NOT NULL,
    [NickName]        NVARCHAR (150) NULL,
    [BirthDate]       DATETIME       NULL,
    [POB]             NVARCHAR (450) NULL,
    [Gender]          BIT            NOT NULL,
    [HL_DistrictCode] NVARCHAR (50)  NULL,
    [HL_ProvinceCode] NVARCHAR (50)  NULL,
    CONSTRAINT [PK_human_Persons] PRIMARY KEY CLUSTERED ([PersonID] ASC),
    CONSTRAINT [FK_human_Persons_hrm_ls_Districts] FOREIGN KEY ([HL_DistrictCode]) REFERENCES [dbo].[hrm_ls_Districts] ([DistrictCode]),
    CONSTRAINT [FK_human_Persons_hrm_ls_Provinces] FOREIGN KEY ([HL_ProvinceCode]) REFERENCES [dbo].[hrm_ls_Provinces] ([ProvinceCode])
);

